alter table bidefault.dm_mng_cn_project_network_summary_dt
    set tblproperties ('external.table.purge' = 'true');
drop table bidefault.dm_mng_cn_project_network_summary_dt;
create external table bidefault.dm_mng_cn_project_network_summary_dt
(
    project_name          string comment '项目名称',
    date_time             string comment '日期',
    customer_network_code string comment '客户所属网点code',
    customer_network_name string comment '客户所属网点name',
    customer_center_code  string comment '客户所属中心code',
    customer_center_name  string comment '客户所属中心name',
    customer_agent_code   string comment '客户所属代理区code',
    customer_agent_name   string comment '客户所属代理区name',
    order_total           int comment '订单总量',
    need_taking_num       int comment '应揽收订单量',
    cancel_num            int comment '取消量',
    actual_taking_num     int comment '实际揽收量',
    no_taking_num         int comment '未揽收量',
    timely_taking_num     int comment '及时揽收量',
    timely_taking_rate    float comment '揽收及时率',
    express_num           int comment '破损量',
    arbitration_nun       int comment '遗失量',
    need_sign_num         int comment ' --应签收量',
    have_sign_num         int comment '签收及时量',
    no_sign_num           int comment '未签收量',
    have_sign_rate        float comment '签收及时率',
    m6_no_sign_num        int comment '超6天未签收量',
    m7_no_sign_num        int comment '超7天未签收量',
    type                  int comment '类型,1是录入时间统计数据,2是揽收时效时间统计数据'
) comment '菜鸟项目报表汇总'
    partitioned by (dt string comment '录入日期')
    STORED AS PARQUET
    LOCATION '/dw/hive/bidefault.db/external/dm_mng_cn_project_network_summary_dt'
;